package net.office.bean;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class AnchorInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public AnchorInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andAnchorIdIsNull() {
            addCriterion("anchor_Id is null");
            return (Criteria) this;
        }

        public Criteria andAnchorIdIsNotNull() {
            addCriterion("anchor_Id is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorIdEqualTo(Integer value) {
            addCriterion("anchor_Id =", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdNotEqualTo(Integer value) {
            addCriterion("anchor_Id <>", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdGreaterThan(Integer value) {
            addCriterion("anchor_Id >", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("anchor_Id >=", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdLessThan(Integer value) {
            addCriterion("anchor_Id <", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdLessThanOrEqualTo(Integer value) {
            addCriterion("anchor_Id <=", value, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdIn(List<Integer> values) {
            addCriterion("anchor_Id in", values, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdNotIn(List<Integer> values) {
            addCriterion("anchor_Id not in", values, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdBetween(Integer value1, Integer value2) {
            addCriterion("anchor_Id between", value1, value2, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorIdNotBetween(Integer value1, Integer value2) {
            addCriterion("anchor_Id not between", value1, value2, "anchorId");
            return (Criteria) this;
        }

        public Criteria andAnchorNoIsNull() {
            addCriterion("anchor_no is null");
            return (Criteria) this;
        }

        public Criteria andAnchorNoIsNotNull() {
            addCriterion("anchor_no is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorNoEqualTo(String value) {
            addCriterion("anchor_no =", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoNotEqualTo(String value) {
            addCriterion("anchor_no <>", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoGreaterThan(String value) {
            addCriterion("anchor_no >", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoGreaterThanOrEqualTo(String value) {
            addCriterion("anchor_no >=", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoLessThan(String value) {
            addCriterion("anchor_no <", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoLessThanOrEqualTo(String value) {
            addCriterion("anchor_no <=", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoLike(String value) {
            addCriterion("anchor_no like", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoNotLike(String value) {
            addCriterion("anchor_no not like", value, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoIn(List<String> values) {
            addCriterion("anchor_no in", values, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoNotIn(List<String> values) {
            addCriterion("anchor_no not in", values, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoBetween(String value1, String value2) {
            addCriterion("anchor_no between", value1, value2, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNoNotBetween(String value1, String value2) {
            addCriterion("anchor_no not between", value1, value2, "anchorNo");
            return (Criteria) this;
        }

        public Criteria andAnchorNameIsNull() {
            addCriterion("anchor_name is null");
            return (Criteria) this;
        }

        public Criteria andAnchorNameIsNotNull() {
            addCriterion("anchor_name is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorNameEqualTo(String value) {
            addCriterion("anchor_name =", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameNotEqualTo(String value) {
            addCriterion("anchor_name <>", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameGreaterThan(String value) {
            addCriterion("anchor_name >", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameGreaterThanOrEqualTo(String value) {
            addCriterion("anchor_name >=", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameLessThan(String value) {
            addCriterion("anchor_name <", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameLessThanOrEqualTo(String value) {
            addCriterion("anchor_name <=", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameLike(String value) {
            addCriterion("anchor_name like", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameNotLike(String value) {
            addCriterion("anchor_name not like", value, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameIn(List<String> values) {
            addCriterion("anchor_name in", values, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameNotIn(List<String> values) {
            addCriterion("anchor_name not in", values, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameBetween(String value1, String value2) {
            addCriterion("anchor_name between", value1, value2, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorNameNotBetween(String value1, String value2) {
            addCriterion("anchor_name not between", value1, value2, "anchorName");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordIsNull() {
            addCriterion("anchor_password is null");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordIsNotNull() {
            addCriterion("anchor_password is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordEqualTo(String value) {
            addCriterion("anchor_password =", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordNotEqualTo(String value) {
            addCriterion("anchor_password <>", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordGreaterThan(String value) {
            addCriterion("anchor_password >", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("anchor_password >=", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordLessThan(String value) {
            addCriterion("anchor_password <", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordLessThanOrEqualTo(String value) {
            addCriterion("anchor_password <=", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordLike(String value) {
            addCriterion("anchor_password like", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordNotLike(String value) {
            addCriterion("anchor_password not like", value, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordIn(List<String> values) {
            addCriterion("anchor_password in", values, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordNotIn(List<String> values) {
            addCriterion("anchor_password not in", values, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordBetween(String value1, String value2) {
            addCriterion("anchor_password between", value1, value2, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorPasswordNotBetween(String value1, String value2) {
            addCriterion("anchor_password not between", value1, value2, "anchorPassword");
            return (Criteria) this;
        }

        public Criteria andAnchorSexIsNull() {
            addCriterion("anchor_sex is null");
            return (Criteria) this;
        }

        public Criteria andAnchorSexIsNotNull() {
            addCriterion("anchor_sex is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorSexEqualTo(Integer value) {
            addCriterion("anchor_sex =", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexNotEqualTo(Integer value) {
            addCriterion("anchor_sex <>", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexGreaterThan(Integer value) {
            addCriterion("anchor_sex >", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("anchor_sex >=", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexLessThan(Integer value) {
            addCriterion("anchor_sex <", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexLessThanOrEqualTo(Integer value) {
            addCriterion("anchor_sex <=", value, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexIn(List<Integer> values) {
            addCriterion("anchor_sex in", values, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexNotIn(List<Integer> values) {
            addCriterion("anchor_sex not in", values, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexBetween(Integer value1, Integer value2) {
            addCriterion("anchor_sex between", value1, value2, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorSexNotBetween(Integer value1, Integer value2) {
            addCriterion("anchor_sex not between", value1, value2, "anchorSex");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayIsNull() {
            addCriterion("anchor_birthday is null");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayIsNotNull() {
            addCriterion("anchor_birthday is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayEqualTo(Date value) {
            addCriterionForJDBCDate("anchor_birthday =", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayNotEqualTo(Date value) {
            addCriterionForJDBCDate("anchor_birthday <>", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayGreaterThan(Date value) {
            addCriterionForJDBCDate("anchor_birthday >", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("anchor_birthday >=", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayLessThan(Date value) {
            addCriterionForJDBCDate("anchor_birthday <", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("anchor_birthday <=", value, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayIn(List<Date> values) {
            addCriterionForJDBCDate("anchor_birthday in", values, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayNotIn(List<Date> values) {
            addCriterionForJDBCDate("anchor_birthday not in", values, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("anchor_birthday between", value1, value2, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorBirthdayNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("anchor_birthday not between", value1, value2, "anchorBirthday");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardIsNull() {
            addCriterion("anchor_id_card is null");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardIsNotNull() {
            addCriterion("anchor_id_card is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardEqualTo(String value) {
            addCriterion("anchor_id_card =", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardNotEqualTo(String value) {
            addCriterion("anchor_id_card <>", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardGreaterThan(String value) {
            addCriterion("anchor_id_card >", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("anchor_id_card >=", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardLessThan(String value) {
            addCriterion("anchor_id_card <", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardLessThanOrEqualTo(String value) {
            addCriterion("anchor_id_card <=", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardLike(String value) {
            addCriterion("anchor_id_card like", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardNotLike(String value) {
            addCriterion("anchor_id_card not like", value, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardIn(List<String> values) {
            addCriterion("anchor_id_card in", values, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardNotIn(List<String> values) {
            addCriterion("anchor_id_card not in", values, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardBetween(String value1, String value2) {
            addCriterion("anchor_id_card between", value1, value2, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorIdCardNotBetween(String value1, String value2) {
            addCriterion("anchor_id_card not between", value1, value2, "anchorIdCard");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeIsNull() {
            addCriterion("anchor_type is null");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeIsNotNull() {
            addCriterion("anchor_type is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeEqualTo(Integer value) {
            addCriterion("anchor_type =", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeNotEqualTo(Integer value) {
            addCriterion("anchor_type <>", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeGreaterThan(Integer value) {
            addCriterion("anchor_type >", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("anchor_type >=", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeLessThan(Integer value) {
            addCriterion("anchor_type <", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeLessThanOrEqualTo(Integer value) {
            addCriterion("anchor_type <=", value, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeIn(List<Integer> values) {
            addCriterion("anchor_type in", values, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeNotIn(List<Integer> values) {
            addCriterion("anchor_type not in", values, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeBetween(Integer value1, Integer value2) {
            addCriterion("anchor_type between", value1, value2, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("anchor_type not between", value1, value2, "anchorType");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelIsNull() {
            addCriterion("anchor_level is null");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelIsNotNull() {
            addCriterion("anchor_level is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelEqualTo(Integer value) {
            addCriterion("anchor_level =", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelNotEqualTo(Integer value) {
            addCriterion("anchor_level <>", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelGreaterThan(Integer value) {
            addCriterion("anchor_level >", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("anchor_level >=", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelLessThan(Integer value) {
            addCriterion("anchor_level <", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelLessThanOrEqualTo(Integer value) {
            addCriterion("anchor_level <=", value, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelIn(List<Integer> values) {
            addCriterion("anchor_level in", values, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelNotIn(List<Integer> values) {
            addCriterion("anchor_level not in", values, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelBetween(Integer value1, Integer value2) {
            addCriterion("anchor_level between", value1, value2, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("anchor_level not between", value1, value2, "anchorLevel");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusIsNull() {
            addCriterion("anchor_status is null");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusIsNotNull() {
            addCriterion("anchor_status is not null");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusEqualTo(Integer value) {
            addCriterion("anchor_status =", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusNotEqualTo(Integer value) {
            addCriterion("anchor_status <>", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusGreaterThan(Integer value) {
            addCriterion("anchor_status >", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("anchor_status >=", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusLessThan(Integer value) {
            addCriterion("anchor_status <", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusLessThanOrEqualTo(Integer value) {
            addCriterion("anchor_status <=", value, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusIn(List<Integer> values) {
            addCriterion("anchor_status in", values, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusNotIn(List<Integer> values) {
            addCriterion("anchor_status not in", values, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusBetween(Integer value1, Integer value2) {
            addCriterion("anchor_status between", value1, value2, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andAnchorStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("anchor_status not between", value1, value2, "anchorStatus");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_Id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_Id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Integer value) {
            addCriterion("staff_Id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("staff_Id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Integer value) {
            addCriterion("staff_Id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("staff_Id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Integer value) {
            addCriterion("staff_Id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("staff_Id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Integer> values) {
            addCriterion("staff_Id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("staff_Id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("staff_Id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("staff_Id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffNoIsNull() {
            addCriterion("staff_no is null");
            return (Criteria) this;
        }

        public Criteria andStaffNoIsNotNull() {
            addCriterion("staff_no is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNoEqualTo(String value) {
            addCriterion("staff_no =", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoNotEqualTo(String value) {
            addCriterion("staff_no <>", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoGreaterThan(String value) {
            addCriterion("staff_no >", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoGreaterThanOrEqualTo(String value) {
            addCriterion("staff_no >=", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoLessThan(String value) {
            addCriterion("staff_no <", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoLessThanOrEqualTo(String value) {
            addCriterion("staff_no <=", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoLike(String value) {
            addCriterion("staff_no like", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoNotLike(String value) {
            addCriterion("staff_no not like", value, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoIn(List<String> values) {
            addCriterion("staff_no in", values, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoNotIn(List<String> values) {
            addCriterion("staff_no not in", values, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoBetween(String value1, String value2) {
            addCriterion("staff_no between", value1, value2, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNoNotBetween(String value1, String value2) {
            addCriterion("staff_no not between", value1, value2, "staffNo");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}